Tabela LStockItemDrugRequestRule

Definicja tabeli LStockItemDrugRequestRule

Name

LStockItemDrugRequestRule

Code

LStockItemDrugRequestRule

Comment

Polaczenie StockItem z DrugRequestRule


Lista kolumn tabeli LStockItemDrugRequestRule

Name

Code

LStockItemDrugRequestRuleID

LStockItemDrugRequestRuleID

StockItemID

StockItemID

StockID

StockID

DrugRequestRuleID

DrugRequestRuleID

StartDT

StartDT

StopDT

StopDT

Active

Active


Kolumna LStockItemDrugRequestRuleID tabeli LStockItemDrugRequestRule

Definicja kolumny LStockItemDrugRequestRuleID tabeli LStockItemDrugRequestRule

Name

LStockItemDrugRequestRuleID

Code

LStockItemDrugRequestRuleID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

ID polaczenia StockItem z DrugRequestRule


Kolumna StockItemID tabeli LStockItemDrugRequestRule

Definicja kolumny StockItemID tabeli LStockItemDrugRequestRule

Name

StockItemID

Code

StockItemID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

ID asortymentu


Kolumna StockID tabeli LStockItemDrugRequestRule

Definicja kolumny StockID tabeli LStockItemDrugRequestRule

Name

StockID

Code

StockID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna DrugRequestRuleID tabeli LStockItemDrugRequestRule

Definicja kolumny DrugRequestRuleID tabeli LStockItemDrugRequestRule

Name

DrugRequestRuleID

Code

DrugRequestRuleID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

ID reguly zamawiania zasobów/leków


Kolumna StartDT tabeli LStockItemDrugRequestRule

Definicja kolumny StartDT tabeli LStockItemDrugRequestRule

Name

StartDT

Code

StartDT

Data Type

DATE

Mandatory

No

Comment

PL: Data poczatku
EN: Start date
DE: das Beginndatum


Kolumna StopDT tabeli LStockItemDrugRequestRule

Definicja kolumny StopDT tabeli LStockItemDrugRequestRule

Name

StopDT

Code

StopDT

Data Type

DATE

Mandatory

No

Comment

PL: Data koncowa
EN: Stop date
DE: Das Endedatum


Kolumna Active tabeli LStockItemDrugRequestRule

Definicja kolumny Active tabeli LStockItemDrugRequestRule

Name

Active

Code

Active

Data Type

NUMBER(10)

Mandatory

No

Comment

PL: Aktywnosc wiersza.
EN: Record's Activity
DE: Aktivitat des Rekord


Lista kluczy tabeli LStockItemDrugRequestRule

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli LStockItemDrugRequestRule

Definicja klucza Identifier_1 tabeli LStockItemDrugRequestRule

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment